USE [RD_FixedAssetsMart]
GO

/****** Object:  Index [PK_FA_Star_Facts]    Script Date: 01/26/2011 15:27:23 ******/
ALTER TABLE [dbo].[FA_Star_Facts] ADD  CONSTRAINT [PK_FA_Star_Facts] PRIMARY KEY CLUSTERED 
(
	[AID] ASC,
	[Century] ASC,
	[FiscalYear] ASC,
	[FiscalQuarter] ASC,
	[AssetItemNumber] ASC,
	[SubLedger] ASC,
	[SubledgerType] ASC,
	[LedgerTypeCode] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO


USE [RD_FixedAssetsMart]
GO

/****** Object:  Index [IX_Facts_Account]    Script Date: 01/26/2011 15:27:18 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_Account] ON [dbo].[FA_Star_Facts] 
(
	[AccountID] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_AccountID]    Script Date: 01/26/2011 15:27:18 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_AccountID] ON [dbo].[FA_Star_Facts] 
(
	[AccountID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_AIDID]    Script Date: 01/26/2011 15:27:18 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_AIDID] ON [dbo].[FA_Star_Facts] 
(
	[AIDID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_AnnDepRule]    Script Date: 01/26/2011 15:27:18 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_AnnDepRule] ON [dbo].[FA_Star_Facts] 
(
	[AnnualDepreciationRuleID] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_AnnualDepreciationRuleID]    Script Date: 01/26/2011 15:27:18 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_AnnualDepreciationRuleID] ON [dbo].[FA_Star_Facts] 
(
	[AnnualDepreciationRuleID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_AssetItemNumber]    Script Date: 01/26/2011 15:27:18 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_AssetItemNumber] ON [dbo].[FA_Star_Facts] 
(
	[AssetItemNumber] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_AssetItemNumberID]    Script Date: 01/26/2011 15:27:18 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_AssetItemNumberID] ON [dbo].[FA_Star_Facts] 
(
	[AssetItemNumberID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_BusinessUnitCode]    Script Date: 01/26/2011 15:27:18 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_BusinessUnitCode] ON [dbo].[FA_Star_Facts] 
(
	[BusinessUnitCode] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_BusinessUnitID]    Script Date: 01/26/2011 15:27:18 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_BusinessUnitID] ON [dbo].[FA_Star_Facts] 
(
	[BusinessUnitID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_CompanyID]    Script Date: 01/26/2011 15:27:18 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_CompanyID] ON [dbo].[FA_Star_Facts] 
(
	[CompanyNumberID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_CompanyNumberID]    Script Date: 01/26/2011 15:27:18 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_CompanyNumberID] ON [dbo].[FA_Star_Facts] 
(
	[CompanyNumberID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_DateDepreStarted]    Script Date: 01/26/2011 15:27:18 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_DateDepreStarted] ON [dbo].[FA_Star_Facts] 
(
	[DateDepreciationStartedID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_DepreciationRuleID]    Script Date: 01/26/2011 15:27:18 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_DepreciationRuleID] ON [dbo].[FA_Star_Facts] 
(
	[DepreciationRuleID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_DepreciationRules]    Script Date: 01/26/2011 15:27:18 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_DepreciationRules] ON [dbo].[FA_Star_Facts] 
(
	[DepreciationMethod] ASC,
	[LifeMonths] ASC,
	[DepreciationInformation] ASC,
	[ComputationMethodITDorRem] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_FiscalYear]    Script Date: 01/26/2011 15:27:18 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_FiscalYear] ON [dbo].[FA_Star_Facts] 
(
	[FiscalYear] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_FiscalYearID]    Script Date: 01/26/2011 15:27:18 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_FiscalYearID] ON [dbo].[FA_Star_Facts] 
(
	[FiscalYearID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_FormulaID]    Script Date: 01/26/2011 15:27:18 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_FormulaID] ON [dbo].[FA_Star_Facts] 
(
	[FormulaID] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_SpreadRule]    Script Date: 01/26/2011 15:27:18 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_SpreadRule] ON [dbo].[FA_Star_Facts] 
(
	[SpreadRuleID] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_SpreadRuleID]    Script Date: 01/26/2011 15:27:18 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_SpreadRuleID] ON [dbo].[FA_Star_Facts] 
(
	[SpreadRuleID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_167]    Script Date: 01/26/2011 15:27:18 ******/
CREATE NONCLUSTERED INDEX [missing_index_167] ON [dbo].[FA_Star_Facts] 
(
	[LedgerTypeCode] ASC,
	[ObjectAccount] ASC
)
INCLUDE ( [FiscalYearID],
[PriorYearCloseBalance],
[NetPosting01],
[NetPosting02],
[NetPosting03],
[NetPosting04],
[NetPosting05],
[NetPosting06],
[NetPosting07],
[NetPosting08],
[NetPosting09],
[NetPosting10]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_169]    Script Date: 01/26/2011 15:27:18 ******/
CREATE NONCLUSTERED INDEX [missing_index_169] ON [dbo].[FA_Star_Facts] 
(
	[AssetAccountType] ASC
)
INCLUDE ( [AssetItemNumberID],
[PriorYearCloseBalance]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_179]    Script Date: 01/26/2011 15:27:18 ******/
CREATE NONCLUSTERED INDEX [missing_index_179] ON [dbo].[FA_Star_Facts] 
(
	[LedgerTypeCode] ASC,
	[ObjectAccount] ASC
)
INCLUDE ( [FiscalYearID],
[PriorYearCloseBalance],
[NetPosting01],
[NetPosting02],
[NetPosting03],
[NetPosting04],
[NetPosting05],
[NetPosting06],
[NetPosting07]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_203]    Script Date: 01/26/2011 15:27:18 ******/
CREATE NONCLUSTERED INDEX [missing_index_203] ON [dbo].[FA_Star_Facts] 
(
	[BusinessUnitID] ASC,
	[LedgerTypeCode] ASC
)
INCLUDE ( [AIDID],
[AssetItemNumberID],
[FiscalYearID],
[PriorYearCloseBalance],
[NetPosting01],
[NetPosting02],
[NetPosting03],
[NetPosting04],
[NetPosting05],
[NetPosting06],
[NetPosting07],
[NetPosting08],
[NetPosting09],
[NetPosting10],
[ObjectAccount],
[Subsidiary]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_206]    Script Date: 01/26/2011 15:27:18 ******/
CREATE NONCLUSTERED INDEX [missing_index_206] ON [dbo].[FA_Star_Facts] 
(
	[BusinessUnitID] ASC,
	[LedgerTypeCode] ASC,
	[ObjectAccount] ASC
)
INCLUDE ( [AssetItemNumberID],
[FiscalYearID],
[PriorYearCloseBalance],
[NetPosting01],
[NetPosting02],
[NetPosting03],
[NetPosting04],
[NetPosting05],
[NetPosting06],
[NetPosting07],
[NetPosting08],
[NetPosting09],
[NetPosting10]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO


